from application import db

class StudyList(db.Model):
    __tablename__ = 'study_list'

    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50, 'utf8mb4_0900_ai_ci'))
    mark = db.Column(db.Integer)
    length= db.Column(db.Integer)
    teacher = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    company = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    department = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    updated_time = db.Column(db.DateTime)
    created_time = db.Column(db.DateTime)
    stime = db.Column(db.Time)
    etime = db.Column(db.Time)
    date = db.Column(db.Date)
    city = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))

    # def __repr__(self):
    #     return '%s' % self.nickname